﻿using System;
using System.Text;
using System.Collections.Generic;
using System.Data;
namespace OneMake.Model
{
    [PetaPoco.TableName("htjy_d_orders")]
    [PetaPoco.PrimaryKey("oid")]
    public class htjy_d_orders
    {
        [MapToField(FieldName = "统计日期")]
        public DateTime stat_datetime { get; set; }

        [MapToExcel(ColumnName = "订单编号")]
        public string order_sn { get; set; }

        [MapToExcel(ColumnName = "买家会员名")]
        public string taobao { get; set; }

        [MapToExcel(ColumnName = "买家支付宝账号")]
        public string alipay { get; set; }

        [MapToExcel(ColumnName = "买家应付货款")]
        public double deal { get; set; }

        [MapToExcel(ColumnName = "买家应付邮费")]
        public double post { get; set; }

        [MapToExcel(ColumnName = "买家支付积分")]
        public int credit { get; set; }

        [MapToExcel(ColumnName = "总金额")]
        public double total_amount { get; set; }

        [MapToExcel(ColumnName = "返点积分")]
        public int return_credit { get; set; }

        [MapToExcel(ColumnName = "买家实际支付金额")]
        public double actual_paid { get; set; }

        [MapToExcel(ColumnName = "买家实际支付积分")]
        public int actual_credit { get; set; }

        [MapToExcel(ColumnName = "订单状态")]
        public string status { get; set; }

        [MapToExcel(ColumnName = "买家留言")]
        public string message { get; set; }

        [MapToExcel(ColumnName = "收货人姓名")]
        public string recv_name { get; set; }

        [MapToExcel(ColumnName = "收货地址")]
        public string recv_address { get; set; }

        [MapToExcel(ColumnName = "运送方式")]
        public string shipment { get; set; }

        [MapToExcel(ColumnName = "联系电话 ")]
        public string telno { get; set; }

        [MapToExcel(ColumnName = "联系手机")]
        public string mobileno { get; set; }

        [MapToExcel(ColumnName = "订单创建时间")]
        public DateTime create_time { get; set; }

        [MapToExcel(ColumnName = "订单付款时间 ")]
        public DateTime paid_time { get; set; }

        [MapToExcel(ColumnName = "宝贝标题 ")]
        public string prd_title { get; set; }

        [MapToExcel(ColumnName = "宝贝种类 ")]
        public int prd_category { get; set; }

        [MapToExcel(ColumnName = "物流单号 ")]
        public string ship_sn { get; set; }

        [MapToExcel(ColumnName = "物流公司")]
        public string ship_company { get; set; }

        [MapToExcel(ColumnName = "订单备注")]
        public string order_remark { get; set; }

        [MapToExcel(ColumnName = "宝贝总数量")]
        public int n_prds { get; set; }

        [MapToExcel(ColumnName = "店铺Id")]
        public int shop_id { get; set; }

        [MapToExcel(ColumnName = "店铺名称")]
        public string shopname { get; set; }

        [MapToExcel(ColumnName = "订单关闭原因")]
        public string close_cause { get; set; }

        [MapToExcel(ColumnName = "卖家服务费")]
        public double seller_fee { get; set; }

        [MapToExcel(ColumnName = "买家服务费")]
        public double buyer_fee { get; set; }

        [MapToExcel(ColumnName = "发票抬头")]
        public string invoice { get; set; }

        [MapToExcel(ColumnName = "是否手机订单")]
        public string mobile_order { get; set; }
        
		/////////////////////////////////////////
        [MapToField(FieldName = "门店编号")]
        public int shopid { get; set; }
        [MapToField(FieldName = "文件编号")]
        public int fileid { get; set; }
        [MapToField(FieldName = "编号")]
        public int oid { get; private set; }    
    }
}